SQL Local Variables and Performance Issues
Updated: 2024-07-31 05:00:00
In this article, we examine the effect of local variables on T-SQL queries and how these could potentially cause performance issues.- In this article, we examine the effect of local variables on T-SQL queries and how these could potentially cause performance issues.
Get Free Access to Azure SQL Database for a Lifetime
Updated: 2024-07-31 05:00:00
Read this article to learn how Azure offers free access to an Azure SQL Database serverless configuration for a lifetime.Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level
Updated: 2024-07-30 05:00:00
Learn about object-level, column-level, and row-level security in the Microsoft Fabric Warehouse and how this can be implemented to limit access to data.Learn how to Create an Azure Function using Visual Studio Code
Updated: 2024-07-30 05:00:00
In this tutorial, learn how to create an Azure function, interact with the Azurite storage account, and edit the function's APIs to integrate with web frameworks.SQL ROUND Function vs. Bankers Rounding with T-SQL
Updated: 2024-07-29 05:00:00
In this article, we look at rounding values using T-SQL and how the ROUND function works compared to creating a user-defined function for bankers rounding.How to Stream Data from Azure Event Hubs into a Fabric Eventhouse
Updated: 2024-07-26 15:43:36
At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for all data-in-motion. This shows the commitment of Microsoft to make Fabric your one-stop shop for all things data analytics, both streaming and batch data. There are several methods to work with streaming data in Fabric, such as eventstream...…
The post How to Stream Data from Azure Event Hubs into a Fabric Eventhouse appeared first on Simple Talk.
Automated PDF Document Summarization with Azure OpenAI
Updated: 2024-07-26 05:00:00
Learn how to use Azure OpenAI API and a custom Python class to create a summarization pipeline that takes a PDF file and produces a summary of the contents.Convert a String to JSON with SQL Server Queries
Updated: 2024-07-25 05:00:00
In this article, we look at various ways to generate JSON formatted data for SQL Server queries using FOR JSON option.Auditing SQL Server – Part 3 – SQL Server Configuration Audit
Updated: 2024-07-25 03:27:02
This is the continuation of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. The next section went over server hardware configuration and audits. This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to...…
The post Auditing SQL Server – Part 3 – SQL Server Configuration Audit appeared first on Simple Talk.
Comparing SQL Server and Oracle Backup Types
Updated: 2024-07-24 05:00:00
Learn about the similarities and differences of backing up a database in SQL Server versus Oracle.Write Logical Expressions using DAX with Power BI Operators and Functions
Updated: 2024-07-23 05:00:00
Learn how to write logical expressions using DAX when working with Power BI with logical operators, functions, and more.SSIS Most Overlooked Features - Fuzzy Lookup, Fuzzy Grouping, Data Profiling and DQS Cleansing
Updated: 2024-07-22 05:00:00
Learn about features to enhance your SSIS projects such as Fuzzy Lookup and Fuzzy Grouping, Data Profiling Task, and DQS Cleansing Transformation.An Introduction to Frappe Framework: Features and Benefits
Updated: 2024-07-19 20:56:50
Frappe is a full-stack, battery-included web framework with MariaDB as the database, written in Python and JavaScript. Frappe is a “batteries included” framework because it equips developers with a comprehensive suite of features for building web applications efficiently. It includes everything from database management, user authentication, and customizable workflows to reporting and API integrations seamlessly...…
The post An Introduction to Frappe Framework: Features and Benefits appeared first on Simple Talk.
Polymorphism in Python Code Examples - Functions, Classes, Inheritance and Duck Typing
Updated: 2024-07-19 05:00:00
Learn about polymorphism in Python with these code examples to learn about functions, classes, inheritance, and duck typing.Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT
Updated: 2024-07-18 05:00:00
This article explores how enabling READ_COMMITTED_SNAPSHOT on your SQL Server database might ease excessive blocking.Express a Number or Currency in Words with T-SQL Code
Updated: 2024-07-16 05:00:00
This SQL script allows you to take a number and convert the number to words, and convert a currency value into words.Normalization in SQL to Reduce Data Redundancy
Updated: 2024-07-15 05:00:00
Various levels of normalization in SQL that can be used to reduce data redundancy and have a better-structured data model. This article looks at these various levels with explanations and examples.Best Practices for Docker to run SQL Server on a Mac
Updated: 2024-07-12 05:00:00
Review this consolidated list of things you can (or should) do when using Docker to run SQL Server on a Mac. Some of this may only apply to M chips, but some apply in any scenario - even Windows.PostgreSQL JSON and JSONB Data Types for Non-Structured or Semi-Structured Data
Updated: 2024-07-11 05:00:00
Learn about the most important syntaxes, features, and possibilities of the PostgreSQL JSON and JSONB data types.Migrate a SQL Server Database to a PostgreSQL Database
Updated: 2024-07-10 05:00:00
Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.Advanced Features of DAB (Data API Builder) to Build a REST API
Updated: 2024-07-09 05:00:00
Get guidance on the advanced features of DAB (Data API Builder) and how to set up a production-ready environment.Create Document Templates in a SQL Server Database Table
Updated: 2024-07-08 05:00:00
In this article, we look at how to create document templates in a database table and use SQL to replace specific keywords in the templates for content customization.